--- Nueva columna en negcfg ----

alter TABLE negcfg
add column fechaproxobligatoria character varying(1);
COMMENT ON COLUMN negcfg.fechaproxobligatoria IS 'Indica si es obligatorio o no cargar la fecha del proximo contacto en cada movimiento';
---------------------------------------------------------------------------------------------------------

--- Cambios en los modelos de reporte de Mayor y SubMayor ----
--- Desaparece el pipe de saldosAnteriores. Los campos con los saldos anteriores pasan a formar parte ---
--- de los pipes de Mayor y Submayor -------------
--- Los modelos originales de Mayor y Submayor se copian por si hay que recuperar algo del modelo en ---
--- Mayor_Ori y SubMayor_Ori respectivamente --- 

insert into repctbg (nombre, id, template, accesousuarios, accesosucursales)
       select 'Mayor_Ori', GetNextId('repctbg'), template, accesousuarios, accesosucursales
       from repctbg
       where nombre = 'Mayor';

update repctbg set template = 
'object rpReporte: TppReport
  AutoStop = False
  DataPipeline = plMayor
  PassSetting = psTwoPass
  PrinterSetup.BinName = ''Default''
  PrinterSetup.DocumentName = ''Reportes''
  PrinterSetup.PaperName = ''A4''
  PrinterSetup.PrinterName = ''Default''
  PrinterSetup.mmMarginBottom = 6350
  PrinterSetup.mmMarginLeft = 6350
  PrinterSetup.mmMarginRight = 6350
  PrinterSetup.mmMarginTop = 6350
  PrinterSetup.mmPaperHeight = 297128
  PrinterSetup.mmPaperWidth = 210080
  PrinterSetup.PaperSize = 9
  SaveAsTemplate = True
  Template.DatabaseSettings.DataPipeline = plReportes
  Template.DatabaseSettings.Name = ''Mayor''
  Template.DatabaseSettings.NameField = ''Nombre''
  Template.DatabaseSettings.TemplateField = ''Template''
  Template.SaveTo = stDatabase
  Template.Format = ftASCII
  Units = utScreenPixels
  DeviceType = ''Screen''
  OnPreviewFormCreate = GcoPreviewFormCreate
  OutlineSettings.CreateNode = True
  OutlineSettings.CreatePageNodes = True
  OutlineSettings.Enabled = False
  Left = 175
  Top = 64
  Version = ''7.0''
  mmColumnWidth = 0
  DataPipelineName = ''plMayor''
  object ppHeaderBand2: TppHeaderBand
    mmBottomOffset = 0
    mmHeight = 26988
    mmPrintPosition = 0
    object ppLine1: TppLine
      UserName = ''LineaEncab''
      Pen.Color = clNavy
      Pen.Width = 2
      ParentWidth = True
      Weight = 1.500000000000000000
      mmHeight = 1588
      mmLeft = 0
      mmTop = 25929
      mmWidth = 197380
      BandType = 0
    end
    object ppLabel3: TppLabel
      UserName = ''TxCodigo''
      AutoSize = False
      Caption = ''C''#243''digo''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 11
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4657
      mmLeft = 1058
      mmTop = 15875
      mmWidth = 24342
      BandType = 0
    end
    object ppLabel4: TppLabel
      UserName = ''TxNombre''
      AutoSize = False
      Caption = ''Nombre''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 11
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4763
      mmLeft = 30956
      mmTop = 15875
      mmWidth = 16140
      BandType = 0
    end
    object ppLabel9: TppLabel
      UserName = ''Label1''
      Caption = ''Fecha''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4304
      mmLeft = 1058
      mmTop = 21167
      mmWidth = 10231
      BandType = 0
    end
    object ppLabel10: TppLabel
      UserName = ''Label2''
      Caption = ''Comp.''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4304
      mmLeft = 30956
      mmTop = 21167
      mmWidth = 11007
      BandType = 0
    end
    object ppLabel11: TppLabel
      UserName = ''Label3''
      Caption = ''Detalle''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4233
      mmLeft = 44186
      mmTop = 21167
      mmWidth = 12965
      BandType = 0
    end
    object ppLabel12: TppLabel
      UserName = ''Label4''
      Caption = ''Debe''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4304
      mmLeft = 137901
      mmTop = 21167
      mmWidth = 8678
      BandType = 0
    end
    object ppLabel13: TppLabel
      UserName = ''Label5''
      Caption = ''Haber''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4304
      mmLeft = 160902
      mmTop = 21167
      mmWidth = 10019
      BandType = 0
    end
    object ppLabel14: TppLabel
      UserName = ''Label6''
      Caption = ''Saldo''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4304
      mmLeft = 186126
      mmTop = 21167
      mmWidth = 9666
      BandType = 0
    end
    object ppLabel2: TppLabel
      UserName = ''Label11''
      Caption = ''Suc.''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4304
      mmLeft = 20902
      mmTop = 21167
      mmWidth = 7408
      BandType = 0
    end
    object ppLabel1: TppLabel
      UserName = ''TxNombreRep''
      AutoSize = False
      Caption = ''Mayor Contable''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 18
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 7479
      mmLeft = 1323
      mmTop = 1058
      mmWidth = 50536
      BandType = 0
    end
    object ppDBTxModo: TppDBText
      UserName = ''DBTxModo''
      AutoSize = True
      DataField = ''Modo''
      DataPipeline = plParam
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 11
      Font.Style = [fsBold]
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = ''plParam''
      mmHeight = 4657
      mmLeft = 55033
      mmTop = 4498
      mmWidth = 10372
      BandType = 0
    end
    object ppLbDel: TppLabel
      UserName = ''Label8''
      Caption = ''Del: ''
      Color = clNavy
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 11
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4657
      mmLeft = 55033
      mmTop = 9525
      mmWidth = 8396
      BandType = 0
    end
    object ppDBTxFechaIni: TppDBText
      UserName = ''DBTxFechaIni''
      DataField = ''FechaInicio''
      DataPipeline = plParam
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = ''plParam''
      mmHeight = 4233
      mmLeft = 63236
      mmTop = 9790
      mmWidth = 18521
      BandType = 0
    end
    object ppLbAl: TppLabel
      UserName = ''Label9''
      Caption = ''al: ''
      Color = clNavy
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 11
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4657
      mmLeft = 83590
      mmTop = 9525
      mmWidth = 5574
      BandType = 0
    end
    object ppDBTxFechaFin: TppDBText
      UserName = ''DBTxFechaFin''
      DataField = ''FechaFin''
      DataPipeline = plParam
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = ''plParam''
      mmHeight = 4233
      mmLeft = 89165
      mmTop = 9790
      mmWidth = 18521
      BandType = 0
    end
    object TxNombreEmpresa: TppDBText
      UserName = ''TxNombreEmpresa''
      Color = clNavy
      DataField = ''Nombre''
      DataPipeline = plEmpresa
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 16
      Font.Style = [fsBold]
      ParentDataPipeline = False
      TextAlignment = taCentered
      Transparent = True
      DataPipelineName = ''plEmpresa''
      mmHeight = 6773
      mmLeft = 125413
      mmTop = 794
      mmWidth = 71438
      BandType = 0
    end
    object TxSubNombreEmpresa: TppDBText
      UserName = ''TxSubNombreEmpresa''
      Color = clNavy
      DataField = ''SubNombre''
      DataPipeline = plEmpresa
      Font.Charset = ANSI_CHARSET
      Font.Color = clWhite
      Font.Name = ''Arial''
      Font.Size = 12
      Font.Style = [fsBold]
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = ''plEmpresa''
      mmHeight = 5027
      mmLeft = 125413
      mmTop = 9260
      mmWidth = 71438
      BandType = 0
    end
  end
  object ppDetailBand: TppDetailBand
    BeforePrint = GcoBandBeforePrint
    PrintHeight = phDynamic
    mmBottomOffset = 0
    mmHeight = 4763
    mmPrintPosition = 0
    object ppDBText7: TppDBText
      UserName = ''DbCodigo''
      DataField = ''Fecha''
      DataPipeline = plMayor
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = ''plMayor''
      mmHeight = 4233
      mmLeft = 1058
      mmTop = 265
      mmWidth = 18521
      BandType = 4
    end
    object ppDBText8: TppDBText
      UserName = ''DbNombre''
      DataField = ''TipoCOM''
      DataPipeline = plMayor
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = ''plMayor''
      mmHeight = 4233
      mmLeft = 30956
      mmTop = 265
      mmWidth = 7673
      BandType = 4
    end
    object ppDBText9: TppDBText
      UserName = ''DbCampo1''
      DataField = ''cfDebe''
      DataPipeline = plMayor
      DisplayFormat = ''###,###,###.00''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      AbacoFormat = rbafCurrency
      DataPipelineName = ''plMayor''
      mmHeight = 4233
      mmLeft = 123825
      mmTop = 265
      mmWidth = 23813
      BandType = 4
    end
    object ppDBText10: TppDBText
      UserName = ''DbCampo2''
      DataField = ''cfHaber''
      DataPipeline = plMayor
      DisplayFormat = ''###,###,###.00''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      AbacoFormat = rbafCurrency
      DataPipelineName = ''plMayor''
      mmHeight = 4233
      mmLeft = 148167
      mmTop = 265
      mmWidth = 23813
      BandType = 4
    end
    object ppDBText12: TppDBText
      UserName = ''DBText3''
      OnGetText = TxtDetalleGetText
      DataField = ''Detalle''
      DataPipeline = plMayor
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      Transparent = True
      DataPipelineName = ''plMayor''
      mmHeight = 4233
      mmLeft = 57679
      mmTop = 265
      mmWidth = 65352
      BandType = 4
    end
    object ppDBCalcParcialMayor: TppDBCalc
      UserName = ''DBCalcParcialMayor''
      DataField = ''cfSaldo''
      DataPipeline = plMayor
      DisplayFormat = ''###,###,###.00''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ResetGroup = ppGroupCta
      TextAlignment = taRightJustified
      Transparent = True
      AbacoFormat = rbafCurrency
      OnGroupBreak = ppDBCalcParcialMayorGroupBreak
      DataPipelineName = ''plMayor''
      mmHeight = 4233
      mmLeft = 172773
      mmTop = 265
      mmWidth = 23813
      BandType = 4
    end
    object ppRegionNroSuc: TppRegion
      OnPrint = ppRegionNroSucPrint
      UserName = ''RegionNroSuc''
      Brush.Color = clWindow
      Pen.Style = psClear
      mmHeight = 4763
      mmLeft = 20108
      mmTop = 0
      mmWidth = 10583
      BandType = 4
      mmBottomOffset = 0
      mmOverFlowOffset = 0
      mmStopPosition = 0
      object ppLabel6: TppLabel
        UserName = ''Label12''
        AutoSize = False
        Caption = ''[ ''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4233
        mmLeft = 20637
        mmTop = 265
        mmWidth = 1588
        BandType = 4
      end
      object ppLabel7: TppLabel
        UserName = ''Label13''
        Caption = '' ]''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4233
        mmLeft = 28045
        mmTop = 265
        mmWidth = 2117
        BandType = 4
      end
      object ppDBText1: TppDBText
        UserName = ''DBText1''
        DataField = ''NroSuc''
        DataPipeline = plMayor
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = ''plMayor''
        mmHeight = 4233
        mmLeft = 21960
        mmTop = 265
        mmWidth = 6350
        BandType = 4
      end
    end
    object ppDBText2: TppDBText
      UserName = ''DBText2''
      DataField = ''Nro''
      DataPipeline = plMayor
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = ''plMayor''
      mmHeight = 4233
      mmLeft = 39158
      mmTop = 265
      mmWidth = 17727
      BandType = 4
    end
  end
  object ppFooterBand2: TppFooterBand
    mmBottomOffset = 0
    mmHeight = 7144
    mmPrintPosition = 0
    object ppLine2: TppLine
      UserName = ''LineaPie''
      Pen.Color = clGray
      Pen.Width = 2
      ParentWidth = True
      Weight = 1.500000000000000000
      mmHeight = 3969
      mmLeft = 0
      mmTop = 5821
      mmWidth = 197380
      BandType = 8
    end
    object ppSystemVariable2: TppSystemVariable
      UserName = ''VarPagina''
      VarType = vtPageSetDesc
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 8
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3440
      mmLeft = 175684
      mmTop = 1323
      mmWidth = 20902
      BandType = 8
    end
  end
  object ppGroupCta: TppGroup
    BreakName = ''CodCta''
    DataPipeline = plMayor
    OutlineSettings.CreateNode = True
    UserName = ''GroupCta''
    mmNewColumnThreshold = 0
    mmNewPageThreshold = 0
    DataPipelineName = ''plMayor''
    object ppGroupHeaderBand2: TppGroupHeaderBand
      BeforePrint = GcoBandBeforePrint
      mmBottomOffset = 0
      mmHeight = 5027
      mmPrintPosition = 0
      object ppDBSaldoAnt: TppDBText
        UserName = ''DBText4''
        DataField = ''cfSaldoAnterior''
        DataPipeline = plMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ParentDataPipeline = False
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        DataPipelineName = ''plMayor''
        mmHeight = 4233
        mmLeft = 173038
        mmTop = 794
        mmWidth = 23813
        BandType = 3
        GroupNo = 0
      end
      object ppDBText19: TppDBText
        UserName = ''DBText19''
        Color = clBlack
        DataField = ''CodCta''
        DataPipeline = plMayor
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        DataPipelineName = ''plMayor''
        mmHeight = 4233
        mmLeft = 1058
        mmTop = 794
        mmWidth = 27517
        BandType = 3
        GroupNo = 1
      end
      object ppDBText20: TppDBText
        UserName = ''DBText20''
        Color = clBlack
        DataField = ''NombreCta''
        DataPipeline = plMayor
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        DataPipelineName = ''plMayor''
        mmHeight = 4233
        mmLeft = 30956
        mmTop = 794
        mmWidth = 69056
        BandType = 3
        GroupNo = 1
      end
      object ppLbSaldoAnt: TppLabel
        UserName = ''Label10''
        Caption = ''Saldo Ant.''
        Font.Charset = ANSI_CHARSET
        Font.Color = clWindowText
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4304
        mmLeft = 103981
        mmTop = 794
        mmWidth = 17427
        BandType = 3
        GroupNo = 0
      end
      object ppDBDebeAnt: TppDBText
        UserName = ''DBDebeAnt''
        DataField = ''SaldoAntDebe''
        DataPipeline = plMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ParentDataPipeline = False
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        DataPipelineName = ''plMayor''
        mmHeight = 4233
        mmLeft = 123825
        mmTop = 794
        mmWidth = 23813
        BandType = 3
        GroupNo = 0
      end
      object ppDBHaberAnt: TppDBText
        UserName = ''DBHaberAnt''
        DataField = ''SaldoAntHaber''
        DataPipeline = plMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ParentDataPipeline = False
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        DataPipelineName = ''plMayor''
        mmHeight = 4233
        mmLeft = 148167
        mmTop = 794
        mmWidth = 23813
        BandType = 3
        GroupNo = 0
      end
    end
    object ppGroupFooterBand2: TppGroupFooterBand
      BeforePrint = GcoBandBeforePrint
      mmBottomOffset = 0
      mmHeight = 7408
      mmPrintPosition = 0
      object ppLabel5: TppLabel
        UserName = ''Label7''
        Caption = ''Saldo''
        Font.Charset = ANSI_CHARSET
        Font.Color = clWindowText
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4304
        mmLeft = 111919
        mmTop = 794
        mmWidth = 9666
        BandType = 5
        GroupNo = 1
      end
      object ppDBCalcSumDebeMayor: TppDBCalc
        UserName = ''DBCalcSumDebeMayor''
        DataField = ''cfDebe''
        DataPipeline = plMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ResetGroup = ppGroupCta
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        OnGroupBreak = ppDBCalcSumDebeMayorGroupBreak
        DataPipelineName = ''plMayor''
        mmHeight = 4233
        mmLeft = 123825
        mmTop = 794
        mmWidth = 23813
        BandType = 5
        GroupNo = 1
      end
      object ppDBCalcSumHaberMayor: TppDBCalc
        UserName = ''DBCalcSumHaberMayor''
        DataField = ''cfHaber''
        DataPipeline = plMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ResetGroup = ppGroupCta
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        OnGroupBreak = ppDBCalcSumHaberMayorGroupBreak
        DataPipelineName = ''plMayor''
        mmHeight = 4233
        mmLeft = 147902
        mmTop = 794
        mmWidth = 23813
        BandType = 5
        GroupNo = 1
      end
      object ppDBCalcSaldoMayor: TppDBCalc
        UserName = ''DBCalcSaldoMayor''
        DataField = ''cfSaldo''
        DataPipeline = plMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ResetGroup = ppGroupCta
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        OnGroupBreak = ppDBCalcSaldoMayorGroupBreak
        DataPipelineName = ''plMayor''
        mmHeight = 4233
        mmLeft = 173038
        mmTop = 794
        mmWidth = 23813
        BandType = 5
        GroupNo = 1
      end
    end
  end
end'
where nombre = 'Mayor';


insert into repctbg (nombre, id, template, accesousuarios, accesosucursales)
       select 'SubMayor_Ori', GetNextId('repctbg'), template, accesousuarios, accesosucursales
       from repctbg
       where nombre = 'SubMayor';

update repctbg set template = 
'object rpReporte: TppReport
  AutoStop = False
  DataPipeline = plSubMayor
  PassSetting = psTwoPass
  PrinterSetup.BinName = ''Default''
  PrinterSetup.DocumentName = ''Reportes''
  PrinterSetup.PaperName = ''A4''
  PrinterSetup.PrinterName = ''Default''
  PrinterSetup.mmMarginBottom = 6350
  PrinterSetup.mmMarginLeft = 6350
  PrinterSetup.mmMarginRight = 6350
  PrinterSetup.mmMarginTop = 6350
  PrinterSetup.mmPaperHeight = 297128
  PrinterSetup.mmPaperWidth = 210080
  PrinterSetup.PaperSize = 9
  SaveAsTemplate = True
  Template.DatabaseSettings.DataPipeline = plReportes
  Template.DatabaseSettings.Name = ''SubMayor''
  Template.DatabaseSettings.NameField = ''Nombre''
  Template.DatabaseSettings.TemplateField = ''Template''
  Template.SaveTo = stDatabase
  Template.Format = ftASCII
  Units = utScreenPixels
  DeviceType = ''Screen''
  OnPreviewFormCreate = GcoPreviewFormCreate
  OutlineSettings.CreateNode = True
  OutlineSettings.CreatePageNodes = True
  OutlineSettings.Enabled = False
  Left = 175
  Top = 64
  Version = ''7.0''
  mmColumnWidth = 0
  DataPipelineName = ''plSubMayor''
  object ppHeaderBand2: TppHeaderBand
    mmBottomOffset = 0
    mmHeight = 26988
    mmPrintPosition = 0
    object ppLine1: TppLine
      UserName = ''LineaEncab''
      Pen.Color = clNavy
      Pen.Width = 2
      ParentWidth = True
      Weight = 1.500000000000000000
      mmHeight = 1588
      mmLeft = 0
      mmTop = 25929
      mmWidth = 197380
      BandType = 0
    end
    object ppLabel3: TppLabel
      UserName = ''TxCodigo''
      AutoSize = False
      Caption = ''C''#243''digo''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 11
      Font.Style = [fsBold]
      Transparent = True
      Visible = False
      mmHeight = 4657
      mmLeft = 1323
      mmTop = 15875
      mmWidth = 20638
      BandType = 0
    end
    object ppLabel4: TppLabel
      UserName = ''TxNombre''
      AutoSize = False
      Caption = ''Nombre''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 11
      Font.Style = [fsBold]
      Transparent = True
      Visible = False
      mmHeight = 4763
      mmLeft = 30956
      mmTop = 15875
      mmWidth = 16404
      BandType = 0
    end
    object ppLabel9: TppLabel
      UserName = ''Label1''
      Caption = ''Fecha''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4304
      mmLeft = 1323
      mmTop = 21167
      mmWidth = 10231
      BandType = 0
    end
    object ppLabel10: TppLabel
      UserName = ''Label2''
      Caption = ''Comp.''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4304
      mmLeft = 32015
      mmTop = 21167
      mmWidth = 11007
      BandType = 0
    end
    object ppLabel11: TppLabel
      UserName = ''Label3''
      Caption = ''Detalle''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4304
      mmLeft = 44979
      mmTop = 21167
      mmWidth = 11642
      BandType = 0
    end
    object ppLabel12: TppLabel
      UserName = ''Label4''
      Caption = ''Debe''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4304
      mmLeft = 139753
      mmTop = 21167
      mmWidth = 8678
      BandType = 0
    end
    object ppLabel13: TppLabel
      UserName = ''Label5''
      Caption = ''Haber''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4304
      mmLeft = 161696
      mmTop = 21167
      mmWidth = 10019
      BandType = 0
    end
    object ppLabel14: TppLabel
      UserName = ''Label6''
      Caption = ''Saldo''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4304
      mmLeft = 187184
      mmTop = 21167
      mmWidth = 9666
      BandType = 0
    end
    object ppLabel2: TppLabel
      UserName = ''Label11''
      Caption = ''Suc.''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4304
      mmLeft = 21960
      mmTop = 21167
      mmWidth = 7408
      BandType = 0
    end
    object ppLabel1: TppLabel
      UserName = ''TxNombreRep''
      AutoSize = False
      Caption = ''Submayor Contable''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 18
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 7479
      mmLeft = 1588
      mmTop = 1323
      mmWidth = 61119
      BandType = 0
    end
    object ppDBTxModo: TppDBText
      UserName = ''DBTxModo''
      AutoSize = True
      DataField = ''Modo''
      DataPipeline = plParam
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 11
      Font.Style = [fsBold]
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = ''plParam''
      mmHeight = 4657
      mmLeft = 66940
      mmTop = 4763
      mmWidth = 10372
      BandType = 0
    end
    object ppLbDel: TppLabel
      UserName = ''Label8''
      Caption = ''Del: ''
      Color = clNavy
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 11
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4657
      mmLeft = 66940
      mmTop = 9790
      mmWidth = 8396
      BandType = 0
    end
    object ppDBTxFechaIni: TppDBText
      UserName = ''DBTxFechaIni''
      DataField = ''FechaInicio''
      DataPipeline = plParam
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = ''plParam''
      mmHeight = 4233
      mmLeft = 75142
      mmTop = 10054
      mmWidth = 18521
      BandType = 0
    end
    object ppLbAl: TppLabel
      UserName = ''Label9''
      Caption = ''al: ''
      Color = clNavy
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 11
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4657
      mmLeft = 95497
      mmTop = 9790
      mmWidth = 5574
      BandType = 0
    end
    object ppDBTxFechaFin: TppDBText
      UserName = ''DBTxFechaFin''
      DataField = ''FechaFin''
      DataPipeline = plParam
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = ''plParam''
      mmHeight = 4233
      mmLeft = 101071
      mmTop = 10054
      mmWidth = 18521
      BandType = 0
    end
    object TxNombreEmpresa: TppDBText
      UserName = ''TxNombreEmpresa''
      AutoSize = True
      Color = clNavy
      DataField = ''Nombre''
      DataPipeline = plEmpresa
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 16
      Font.Style = [fsBold]
      ParentDataPipeline = False
      TextAlignment = taCentered
      Transparent = True
      DataPipelineName = ''plEmpresa''
      mmHeight = 6646
      mmLeft = 128796
      mmTop = 1058
      mmWidth = 64939
      BandType = 0
    end
    object TxSubNombreEmpresa: TppDBText
      UserName = ''TxSubNombreEmpresa''
      Color = clNavy
      DataField = ''SubNombre''
      DataPipeline = plEmpresa
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 12
      Font.Style = [fsBold]
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = ''plEmpresa''
      mmHeight = 5027
      mmLeft = 125413
      mmTop = 9525
      mmWidth = 71438
      BandType = 0
    end
  end
  object ppDetailBand: TppDetailBand
    BeforePrint = GcoBandBeforePrint
    PrintHeight = phDynamic
    mmBottomOffset = 0
    mmHeight = 4763
    mmPrintPosition = 0
    object ppDBText7: TppDBText
      UserName = ''DbCodigo''
      DataField = ''Fecha''
      DataPipeline = plSubMayor
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = ''plSubMayor''
      mmHeight = 4233
      mmLeft = 1323
      mmTop = 265
      mmWidth = 18521
      BandType = 4
    end
    object ppDBText8: TppDBText
      UserName = ''DbNombre''
      DataField = ''TipoCOM''
      DataPipeline = plSubMayor
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = ''plSubMayor''
      mmHeight = 4233
      mmLeft = 30956
      mmTop = 265
      mmWidth = 6085
      BandType = 4
    end
    object ppDBText9: TppDBText
      UserName = ''DbCampo1''
      DataField = ''cfDebe''
      DataPipeline = plSubMayor
      DisplayFormat = ''###,###,###.00''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      AbacoFormat = rbafCurrency
      DataPipelineName = ''plSubMayor''
      mmHeight = 4233
      mmLeft = 123561
      mmTop = 265
      mmWidth = 23813
      BandType = 4
    end
    object ppDBText10: TppDBText
      UserName = ''DbCampo2''
      DataField = ''cfHaber''
      DataPipeline = plSubMayor
      DisplayFormat = ''###,###,###.00''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      AbacoFormat = rbafCurrency
      DataPipelineName = ''plSubMayor''
      mmHeight = 4233
      mmLeft = 147902
      mmTop = 265
      mmWidth = 23813
      BandType = 4
    end
    object ppDBText12: TppDBText
      UserName = ''DBText3''
      DataField = ''cfDetalleEntidad''
      DataPipeline = plSubMayor
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = ''plSubMayor''
      mmHeight = 4233
      mmLeft = 53446
      mmTop = 265
      mmWidth = 69586
      BandType = 4
    end
    object ppDBCalcParcialMayor: TppDBCalc
      UserName = ''DBCalcParcialMayor''
      DataField = ''cfSaldo''
      DataPipeline = plSubMayor
      DisplayFormat = ''###,###,###.00''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      ParentDataPipeline = False
      ResetGroup = ppGroupCta
      TextAlignment = taRightJustified
      Transparent = True
      AbacoFormat = rbafCurrency
      OnGroupBreak = ppDBCalcParcialMayorGroupBreak
      DataPipelineName = ''plSubMayor''
      mmHeight = 4233
      mmLeft = 173038
      mmTop = 265
      mmWidth = 23813
      BandType = 4
    end
    object ppRegionNroRef: TppRegion
      OnPrint = ppRegionNroSucPrint
      UserName = ''RegionNroRef''
      Brush.Color = clWindow
      Pen.Style = psClear
      mmHeight = 4763
      mmLeft = 20108
      mmTop = 0
      mmWidth = 10583
      BandType = 4
      mmBottomOffset = 0
      mmOverFlowOffset = 0
      mmStopPosition = 0
      object ppLabel6: TppLabel
        UserName = ''Label12''
        AutoSize = False
        Caption = ''[ ''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4233
        mmLeft = 20902
        mmTop = 265
        mmWidth = 1588
        BandType = 4
      end
      object ppLabel7: TppLabel
        UserName = ''Label13''
        Caption = '' ]''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4233
        mmLeft = 28310
        mmTop = 265
        mmWidth = 2117
        BandType = 4
      end
      object ppDBText1: TppDBText
        UserName = ''DBText1''
        DataField = ''NroSuc''
        DataPipeline = plSubMayor
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = ''plSubMayor''
        mmHeight = 4233
        mmLeft = 22225
        mmTop = 265
        mmWidth = 6350
        BandType = 4
      end
    end
    object ppDBText2: TppDBText
      UserName = ''DBText2''
      DataField = ''Nro''
      DataPipeline = plSubMayor
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = ''plSubMayor''
      mmHeight = 4233
      mmLeft = 37571
      mmTop = 265
      mmWidth = 15346
      BandType = 4
    end
  end
  object ppFooterBand2: TppFooterBand
    mmBottomOffset = 0
    mmHeight = 7144
    mmPrintPosition = 0
    object ppLine2: TppLine
      UserName = ''LineaPie''
      Pen.Color = clGray
      Pen.Width = 2
      ParentWidth = True
      Weight = 1.500000000000000000
      mmHeight = 3969
      mmLeft = 0
      mmTop = 5821
      mmWidth = 197380
      BandType = 8
    end
    object ppSystemVariable2: TppSystemVariable
      UserName = ''VarPagina''
      VarType = vtPageSetDesc
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Arial''
      Font.Size = 8
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3440
      mmLeft = 175419
      mmTop = 1323
      mmWidth = 20902
      BandType = 8
    end
  end
  object ppGroupCta: TppGroup
    BreakName = ''CodCta''
    DataPipeline = plSubMayor
    OutlineSettings.CreateNode = True
    UserName = ''GroupCta''
    mmNewColumnThreshold = 0
    mmNewPageThreshold = 0
    DataPipelineName = ''plSubMayor''
    object ppGroupHeaderMayor: TppGroupHeaderBand
      BeforePrint = GcoBandBeforePrint
      mmBottomOffset = 0
      mmHeight = 5027
      mmPrintPosition = 0
      object ppDBSaldoAnt: TppDBText
        UserName = ''DBText4''
        DataField = ''cfSaldoAnterior''
        DataPipeline = plSubMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ParentDataPipeline = False
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        DataPipelineName = ''plSubMayor''
        mmHeight = 4233
        mmLeft = 173038
        mmTop = 794
        mmWidth = 23813
        BandType = 3
        GroupNo = 0
      end
      object ppDBCodCta: TppDBText
        UserName = ''DBCodCta''
        Color = clBlack
        DataField = ''CodCta''
        DataPipeline = plSubMayor
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ParentDataPipeline = False
        Transparent = True
        DataPipelineName = ''plSubMayor''
        mmHeight = 4233
        mmLeft = 1323
        mmTop = 794
        mmWidth = 27517
        BandType = 3
        GroupNo = 1
      end
      object ppDBText20: TppDBText
        UserName = ''DBText20''
        Color = clBlack
        DataField = ''NombreCta''
        DataPipeline = plSubMayor
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ParentDataPipeline = False
        Transparent = True
        DataPipelineName = ''plSubMayor''
        mmHeight = 4233
        mmLeft = 30956
        mmTop = 794
        mmWidth = 72496
        BandType = 3
        GroupNo = 1
      end
      object ppLbSaldoAnt: TppLabel
        UserName = ''Label10''
        Caption = ''Saldo Ant.''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4304
        mmLeft = 105569
        mmTop = 794
        mmWidth = 17427
        BandType = 3
        GroupNo = 0
      end
      object ppDBDebeAnt: TppDBText
        UserName = ''DBDebeAnt''
        DataField = ''saldoantdebe''
        DataPipeline = plSubMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ParentDataPipeline = False
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        DataPipelineName = ''plSubMayor''
        mmHeight = 4233
        mmLeft = 123561
        mmTop = 794
        mmWidth = 23813
        BandType = 3
        GroupNo = 0
      end
      object ppDBHaberAnt: TppDBText
        UserName = ''DBHaberAnt''
        DataField = ''saldoanthaber''
        DataPipeline = plSubMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ParentDataPipeline = False
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        DataPipelineName = ''plSubMayor''
        mmHeight = 4233
        mmLeft = 147902
        mmTop = 794
        mmWidth = 23813
        BandType = 3
        GroupNo = 0
      end
    end
    object ppGroupFooterBand2: TppGroupFooterBand
      BeforePrint = GcoBandBeforePrint
      mmBottomOffset = 0
      mmHeight = 7408
      mmPrintPosition = 0
      object ppLabel5: TppLabel
        UserName = ''Label7''
        Caption = ''Saldo''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4304
        mmLeft = 111919
        mmTop = 794
        mmWidth = 9666
        BandType = 5
        GroupNo = 1
      end
      object ppDBCalcSumDebeMayor: TppDBCalc
        UserName = ''DBCalcSumDebeMayor''
        DataField = ''cfDebe''
        DataPipeline = plSubMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ParentDataPipeline = False
        ResetGroup = ppGroupCta
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        OnGroupBreak = ppDBCalcSumDebeMayorGroupBreak
        DataPipelineName = ''plSubMayor''
        mmHeight = 4233
        mmLeft = 123561
        mmTop = 794
        mmWidth = 23813
        BandType = 5
        GroupNo = 1
      end
      object ppDBCalcSumHaberMayor: TppDBCalc
        UserName = ''DBCalcSumHaberMayor''
        DataField = ''cfHaber''
        DataPipeline = plSubMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ParentDataPipeline = False
        ResetGroup = ppGroupCta
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        OnGroupBreak = ppDBCalcSumHaberMayorGroupBreak
        DataPipelineName = ''plSubMayor''
        mmHeight = 4233
        mmLeft = 147902
        mmTop = 794
        mmWidth = 23813
        BandType = 5
        GroupNo = 1
      end
      object ppDBCalcSaldoMayor: TppDBCalc
        UserName = ''DBCalcSaldoMayor''
        DataField = ''cfSaldo''
        DataPipeline = plSubMayor
        DisplayFormat = ''###,###,###.00''
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = ''Arial''
        Font.Size = 10
        Font.Style = [fsBold]
        ParentDataPipeline = False
        ResetGroup = ppGroupCta
        TextAlignment = taRightJustified
        Transparent = True
        AbacoFormat = rbafCurrency
        OnGroupBreak = ppDBCalcSaldoMayorGroupBreak
        DataPipelineName = ''plSubMayor''
        mmHeight = 4233
        mmLeft = 173038
        mmTop = 794
        mmWidth = 23813
        BandType = 5
        GroupNo = 1
      end
    end
  end
end'
where nombre = 'SubMayor';

---------------------------------------------------------------------------------------------------

-- =====================================
SELECT aaversion('405.00');
-- =====================================

       